Tabela PhBlockadeLot

Definicja tabeli PhBlockadeLot

Name

PhBlockadeLot

Code

PhBlockadeLot

Comment

Tabela wskazujaca konkretne blokowane dostawy leków


Lista kolumn tabeli PhBlockadeLot

Name

Code

BlockadeLotID

BlockadeLotID

BlockadeID

BlockadeID

LotNo

LotNo

LotId

LotId

Active

Active


Kolumna BlockadeLotID tabeli PhBlockadeLot

Definicja kolumny BlockadeLotID tabeli PhBlockadeLot

Name

BlockadeLotID

Code

BlockadeLotID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID blokady serii leku


Kolumna BlockadeID tabeli PhBlockadeLot

Definicja kolumny BlockadeID tabeli PhBlockadeLot

Name

BlockadeID

Code

BlockadeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LotNo tabeli PhBlockadeLot

Definicja kolumny LotNo tabeli PhBlockadeLot

Name

LotNo

Code

LotNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer serii


Kolumna LotId tabeli PhBlockadeLot

Definicja kolumny LotId tabeli PhBlockadeLot

Name

LotId

Code

LotId

Data Type

NUMBER(10)

Mandatory

No

Comment

klucz obcy do tabeli PhLot


Kolumna Active tabeli PhBlockadeLot

Definicja kolumny Active tabeli PhBlockadeLot

Name

Active

Code

Active

Data Type

NUMBER(10)

Mandatory

No

Comment

czy dla danego lota zostala zakonczona blokada


Lista kluczy tabeli PhBlockadeLot

Name

Code

Primary

Key_1

Key_1

X


Klucz Key_1 tabeli PhBlockadeLot

Definicja klucza Key_1 tabeli PhBlockadeLot

Name

Key_1

Code

Key_1

Primary

Yes

Comment